﻿CREATE TABLE [dbo].[ASMS_ServiceItemRetain]
(
	[Id] uniqueidentifier NOT NULL PRIMARY KEY,
	[BusinessId] uniqueidentifier NOT NULL,
	[StationId] uniqueidentifier,
	[ServiceItemId] uniqueidentifier NOT NULL,
    [Price] money NOT NULL,
	[Discount] money not null,
	[TaxRate] money not null,
	[SalesCommission] money not null,
    [SalesCommissionType] int not null,
	[TechnicianCommission] money not null,
	[TechnicianCommissionType] int not null,
	[Status] int NOT NULL,
	[CreatedTime] datetime not null,
	[Creator] nvarchar(64) not null
)
